From 7d6b6009278e77083132500c1c98c258fe499988 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sat, 18 Jul 2026 00:59:26 +0000 Subject: [PATCH] Create, document, index, and trigger ELO_RANKS_DAILY_KK_M --- db/schemas/lib/triggers/Makefile | 1 + .../triggers/create/elo_ranks_daily_kk_m.m4 | 27 +++++++++++++++++++ .../lib/triggers/drop/elo_ranks_daily_kk_m.m4 | 24 +++++++++++++++++ db/schemas/sokwedb/indexes/Makefile | 2 +- .../indexes/create/elo_ranks_daily_kk_m.m4 | 24 +++++++++++++++++ .../indexes/drop/elo_ranks_daily_kk_m.m4 | 24 +++++++++++++++++ db/schemas/sokwedb/tables/Makefile | 1 + .../tables/create/elo_ranks_daily_kk_m.m4 | 26 ++++++++++++++++++ doc/src/analyzed.m4 | 1 + doc/src/analyzed/elo_ranks_daily_kk_m.m4 | 22 +++++++++++++++ doc/src/epilog.inc.m4 | 3 +++ 11 files changed, 154 insertions(+), 1 deletion(-) create mode 100644 db/schemas/lib/triggers/create/elo_ranks_daily_kk_m.m4 create mode 100644 db/schemas/lib/triggers/drop/elo_ranks_daily_kk_m.m4 create mode 100644 db/schemas/sokwedb/indexes/create/elo_ranks_daily_kk_m.m4 create mode 100644 db/schemas/sokwedb/indexes/drop/elo_ranks_daily_kk_m.m4 create mode 100644 db/schemas/sokwedb/tables/create/elo_ranks_daily_kk_m.m4 create mode 100644 doc/src/analyzed/elo_ranks_daily_kk_m.m4 diff --git a/db/schemas/lib/triggers/Makefile b/db/schemas/lib/triggers/Makefile index 1c365dd..e7bfab3 100644 --- a/db/schemas/lib/triggers/Makefile +++ b/db/schemas/lib/triggers/Makefile @@ -53,6 +53,7 @@ ORDER := comm_ids \ colobus \ matings \ elo_ranks_daily_kk_f \ + elo_ranks_daily_kk_m \ elo_ranks_daily_mt_f DROP_EXISTING := true diff --git a/db/schemas/lib/triggers/create/elo_ranks_daily_kk_m.m4 b/db/schemas/lib/triggers/create/elo_ranks_daily_kk_m.m4 new file mode 100644 index 0000000..bf13fa5 --- /dev/null +++ b/db/schemas/lib/triggers/create/elo_ranks_daily_kk_m.m4 @@ -0,0 +1,27 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc. http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify it +dnl under the terms of the GNU Affero General Public License as published by +dnl the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Triggers for the elo_ranks_daily_kk_m table +dnl +dnl Karl O. Pinc + +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`macros.m4')dnl +include(`elo_ranks_daily_triggers_create.m4')dnl + + +elo_ranks_daily_triggers_create(`male', sdb_male, `KK') diff --git a/db/schemas/lib/triggers/drop/elo_ranks_daily_kk_m.m4 b/db/schemas/lib/triggers/drop/elo_ranks_daily_kk_m.m4 new file mode 100644 index 0000000..563008f --- /dev/null +++ b/db/schemas/lib/triggers/drop/elo_ranks_daily_kk_m.m4 @@ -0,0 +1,24 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc. http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published by +dnl the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Drop triggers for elo_ranks_daily_kk_m table +dnl +dnl Karl O. Pinc + +dnl m4 includes +include(`copyright.m4')dnl +include(`elo_ranks_daily_triggers_drop.m4')dnl + +elo_ranks_daily_triggers_drop(sdb_male, `KK') diff --git a/db/schemas/sokwedb/indexes/Makefile b/db/schemas/sokwedb/indexes/Makefile index 9646662..b1b0dd1 100644 --- a/db/schemas/sokwedb/indexes/Makefile +++ b/db/schemas/sokwedb/indexes/Makefile @@ -25,7 +25,7 @@ ORDER := biography_data biography_log comm_membs comm_memb_log \ aggressions food_events groomings attendance \ arrivals_a species_present repro_states locations_utm \ locations_paper colobus matings fertility elo_ranks_daily_kk_f \ - elo_ranks_daily_mt_f + elo_ranks_daily_kk_m elo_ranks_daily_mt_f ## ## CAUTION: This Makefile is not designed to be run directly. It is normally diff --git a/db/schemas/sokwedb/indexes/create/elo_ranks_daily_kk_m.m4 b/db/schemas/sokwedb/indexes/create/elo_ranks_daily_kk_m.m4 new file mode 100644 index 0000000..80cdeda --- /dev/null +++ b/db/schemas/sokwedb/indexes/create/elo_ranks_daily_kk_m.m4 @@ -0,0 +1,24 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`indexmacros.m4')dnl + +elo_ranks_daily_indexes_create(sdb_male, `KK') diff --git a/db/schemas/sokwedb/indexes/drop/elo_ranks_daily_kk_m.m4 b/db/schemas/sokwedb/indexes/drop/elo_ranks_daily_kk_m.m4 new file mode 100644 index 0000000..9915431 --- /dev/null +++ b/db/schemas/sokwedb/indexes/drop/elo_ranks_daily_kk_m.m4 @@ -0,0 +1,24 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`indexmacros.m4')dnl + +elo_ranks_daily_indexes_drop(sdb_male, `KK') diff --git a/db/schemas/sokwedb/tables/Makefile b/db/schemas/sokwedb/tables/Makefile index 7b81e5b..6ed2b1e 100644 --- a/db/schemas/sokwedb/tables/Makefile +++ b/db/schemas/sokwedb/tables/Makefile @@ -52,6 +52,7 @@ ORDER := biography_data \ matings \ fertility \ elo_ranks_daily_kk_f \ + elo_ranks_daily_kk_m \ elo_ranks_daily_mt_f ## diff --git a/db/schemas/sokwedb/tables/create/elo_ranks_daily_kk_m.m4 b/db/schemas/sokwedb/tables/create/elo_ranks_daily_kk_m.m4 new file mode 100644 index 0000000..050c330 --- /dev/null +++ b/db/schemas/sokwedb/tables/create/elo_ranks_daily_kk_m.m4 @@ -0,0 +1,26 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`tablemacros.m4')dnl +include(`grants.m4')dnl +dnl + +elo_ranks_daily_table(sdb_male, `KK') diff --git a/doc/src/analyzed.m4 b/doc/src/analyzed.m4 index a8bd791..b9a1f80 100644 --- a/doc/src/analyzed.m4 +++ b/doc/src/analyzed.m4 @@ -32,6 +32,7 @@ a rudimentary analytical process. :maxdepth: 3 analyzed/elo_ranks_daily_kk_f.rst + analyzed/elo_ranks_daily_kk_m.rst analyzed/elo_ranks_daily_mt_f.rst analyzed/fertility.rst analyzed/repro_states.rst diff --git a/doc/src/analyzed/elo_ranks_daily_kk_m.m4 b/doc/src/analyzed/elo_ranks_daily_kk_m.m4 new file mode 100644 index 0000000..36916d6 --- /dev/null +++ b/doc/src/analyzed/elo_ranks_daily_kk_m.m4 @@ -0,0 +1,22 @@ +.. Copyright (C) 2026 The Meme Factory, Inc. www.karlpinc.com + + This program is free software: you can redistribute it and/or modify + it under the terms of the GNU Affero General Public License as + published by the Free Software Foundation, either version 3 of the + License, or (at your option) any later version. + + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU Affero General Public License for more details. + + You should have received a copy of the GNU Affero General Public License + along with this program. If not, see . + +.. M4 setup +include(constants.m4)dnl +include(macros.m4)dnl +include(elo_ranks_daily_macro.m4)dnl +sdb_generated_rst()dnl + +elo_ranks_daily_macro(male, sdb_male, KK) diff --git a/doc/src/epilog.inc.m4 b/doc/src/epilog.inc.m4 index 83d381e..46b72ed 100644 --- a/doc/src/epilog.inc.m4 +++ b/doc/src/epilog.inc.m4 @@ -396,6 +396,9 @@ sdb_generated_rst()dnl .. ELO_RANKS_DAILY_KK_F elo_ranks_daily_rst(sdb_female, KK)dnl +.. ELO_RANKS_DAILY_KK_M +elo_ranks_daily_rst(sdb_male, KK)dnl + .. ELO_RANKS_DAILY_MT_F elo_ranks_daily_rst(sdb_female, MT)dnl -- 2.34.1